dspConduct
Build the Request-related Objects
NOTE: Objects can be built once. After the objects have been built successfully, there is no method for building them again from within dspConduct™ or the DSP®. If objects must be rebuilt, they must be manually updated in the database.
Before performing this task, these prerequisites must have been met:
- An empty database that will be used for the Content WebApp must exist.
- A data source that uses that database must be registered in the DSP®.
- A WebApp that uses that data source must be added in the DSP®.
Once the prerequisites exist, create a dspConduct™ Category that uses the WebApp as its Default Web App.
To build the request-related objects:
- Click Vertical View for the Category.
- Click the Rules and Actions tab.
-
Click the Create Default Web App Request Table and Views icon.
NOTE: The pages that display allow the user to create the request-related objects in the WebApp and the database, and this icon is active if those objects have not been built. After the objects have been built successfully, the Create Default Web App Request Table and Views icon is disabled and these pages can no longer be accessed.
NOTE: These pages display the default ttRequest table and page column definitions that will be used when building the objects. These default settings can be used to meet most business needs, and it is recommended that they not be updated. A user can choose to customize or add page column before the request-related objects are auto-generated, but all custom code must be maintained by the Designer. Refer to the field descriptions for the Default Web App Request Table Columns page for information about the type of data to enter in this field if needed.
NOTE: The auto-generation process creates table columns and page columns that are not associated with columns in the underlying table. A column is a page column only when the value in the COLUMN ORDER field is 0.
-
Click Build Objects in the Page toolbar on the Default WebApp Request Table page to auto-generate the tables, views and stored procedures.
The tables ttRequest, ttRequestOrgUnit1, ttRequestOrgUnit2 and ttRequestOrgUnit3 are created, along with the following objects.
Object |
Description |
webDefaultWebAppRequestTable_BuildObjects_ztParamIns |
Creates table ztParam in Content WebApp's database if it doesn't exist already. |
webDefaultWebAppRequestTable_BuildObjects_DGEViewsIns |
Creates views in Content WebApp's database; views provide access to DGE tables. |
webDefaultWebAppRequestTable_BuildObjects_DGEListViewsIns |
Creates views in Content WebApp's database used as List views on Request page. |
webDefaultWebAppRequestTable_BuildObjects_CreateTablesIns |
Determines if Request-related tables exist in the Content WebApp's database and calls the logic to create them if they don't exist. |
webDefaultWebAppRequestTable_BuildObjects_ttRequestTriggerIns |
Creates trigger on table ttRequest in the Content WebApp's database if it doesn't exist. |
webDefaultWebAppRequestTable_BuildObjects_OnValidateSubmitViewsIns |
Creates views in the Content WebApp's database used by the Request OnValidate stored procedures and the Submit procedures. |
webDefaultWebAppRequestTable_BuildObjects_OnValidateProceduresIns |
Creates stored procedures in the Content WebApp's database used by the Request OnValidate event. Also creates stored procedures used by the Request OrgUnit page's OnValidate event. |
webDefaultWebAppRequestTable_BuildObjects_SubmitProceduresIns |
Creates stored procedures in the Content WebApp's database used by the Request Submit event. |
webDefaultWebAppRequestTable_BuildObjects_PageViewsIns |
Creates Request-related page views in the Content WebApp's database. |
webDefaultWebAppRequestTable_BuildObjects_CreatePagesIns |
Creates Request-related pages and page events in the Content WebApp. |
webDefaultWebAppRequestTable_BuildObjects_RegisterEventRulesIns |
Registers specific procedures to the Request-related pages' events. |
webDefaultWebAppRequestTable_BuildObjects_UpdatePagePropertiesUpd |
Registers DCV, PCV to the Request-related pages. Sets Insert, Update, and Support Delete properties. |
webDefaultWebAppRequestTable_BuildObjects_UpdateRequestBuildStatusUpd |
Set BuildStatus to true for Request-related ttTable records. |
webDefaultWebAppRequestTable_BuildObjects_DefaultViewsCreatedUpd |
After all the Request-related objects have been created, updates ttCategory DefaultWebAppViewsCreated bit to 1. |
The following pages are created in the Content WebApp:
- [WebApp name] – A static landing page for the Content WebApp that displays when the user clicks the WebApp name in the Navigation pane.
- Reports – A page listing links to custom reports to be developed on site.
- Request – A page used by users to enter request data and submit it to dspConduct™, created based on the table and page column definitions on the Default WebApp Request Table page and the Default WebApp Request Table Columns page.
- Request Details – A page that displays a visual representation of an active request’s process through the workflow, including which roles have been completed for the request.
- Request Org Unit 1 – 3 – If Org Unit Types have been defined for the Category, the Organization Unit pages are used to enter Org Unit values in addition to values entered on the main Request page.